package com.heima.datasync.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.heima.model.article.pojos.ApArticle;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ApArticleMapper extends BaseMapper<ApArticle> {

    @Select("SELECT aa.*\n" +
            "from\n" +
            "ap_article aa,\n" +
            "ap_article_config aac\n" +
            "where aa.id=aac.article_id\n" +
            "and aac.is_delete !=1 and \n" +
            "aac.is_down !=1")
    List<ApArticle> findAllArticles();
}
